<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<form method ="POST" >
    Max<input type ="text" name ="username"></br>
    Min<input type ="password" name="password"></br>
    <input type="submit" name="submit" value="Search">
</form>
<?php
require_once '../config/config.php';
$connection = mysql_connect(DB_HOST . ":" . DB_PORT, DB_USER, DB_PASS) or die(mysql_error());            
mysql_select_db(DB_NAME, $connection); 

$query = "SELECT * FROM pages LIMIT 0,20" ;
$data = mysql_query($query, $connection);





echo "<table border='1'>
    <tr>
    
<th> PID </th>
<th> ID </th>
<th> NAME </th>
<th> USER NAME </th>
<th> PHONE </th>
<th> LIKES </th>
<th> TALKING ABOUT COUNT </th>
<th> CATEGORY </th>
<th> LINK </th>
<th> URL </th>
<th> WEBSITE </th>
<th> PICTURE </th>
<th> STREET </th>
<th> CITY </th>
<th> COUNTRY </th>
<th> DESCRIPTION </th>
<th> ABOUT </th>
<th> NOTE </th>
<th> DATE </th>
<th> STATUS </th>
    </tr>";
    
while ($row = mysql_fetch_assoc($data)) { {   
    
      
          echo"<tr>";  
          echo "<td>".$row['pid']."</td>";
          echo "<td>" .$row["id"]."</td>";
          echo "<td>" .$row["name"]."</td>";
          echo "<td>" .$row["username"]."</td>";
          echo "<td>" .$row["phone"]."</td>";
          echo "<td>" .$row["likes"]."</td>";
          echo "<td>" .$row["talking_about_count"]."</td>";
          echo "<td>" .$row["category"]."</td>";
          echo "<td>" .$row["link"]."</td>";
          echo "<td>" .$row["url"]."</td>";
          echo "<td>" .$row["website"]."</td>";
          echo "<td>" .$row["picture"]."</td>";
          echo "<td>" .$row["street"]."</td>";
          echo "<td>" .$row["city"]."</td>";
          echo "<td>" .$row["country"]."</td>";
          echo "<td>" .$row["description"]."</td>";
          echo "<td>" .$row["about"]."</td>";
          echo "<td>" .$row["note"]."</td>";
          echo "<td>" .$row["date"]."</td>";
          echo "<td>" .$row["status"]."</td>";
          echo "</tr>";
         
       }}
   echo "</table>";
  ?>